home *** CD-ROM | disk | FTP | other *** search
/ PsL Monthly 1995 August / PSL Monthly Shareware CD-ROM Volume 3 Number 8 (Public Software Library).bin / screens / fw10.bmp (.png) < prev    next >
Bitmap Image  |  1995-07-05  |  46KB  |  640x480  |  4-bit (11 colors)
Labels: text | electronics | screenshot | display | software | number | web page | computer icon | font | website
OCR: FlexEasy - [1 C:\FLEXEASY\SAMPLES\FINANFN.FLX] File Edit Search Cells Evaluate Ranges Graphs Window Help Active File 1.743 ML Principle: P=100000 Years: Y=25 + Interest (%) Payment ($/month) 8.00 775.84 This example shows the use of the MTG 8.25 792.52 ( mortgage) function. The interest rate 8.50 809.33 is varied and the effect on the monthly 8.75 826.29 payment is shown. The interest rate is 9.00 843.37 given as a location on the sheet. Note 9.25 860.58 how the principle and number of years 9.50 877.92 can also be varied. For this example 9.75 895.37 the mortgage payments are made 12 times 10.00 912.95 per year. The interest is compounded 10.25 930.63 twice per year . 10.50 948.43 10.75 966.34 The sheet RELATIVE.FRE contains the MTG 11.00 984.36 function in a table with both the term 11.25 1002.47 and the interest rate varying. 11.50 1020.69 11.75 1039.00 12.00 1057.40 12.25 1075.96 12.50 1094.48 12.75 1113.15 F1=Help Alt=Menu F7=Eval cell F9=Eval all cells 0040:0001